SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Cottage Hill Farm is a rare opportunity to experience the beauty, character, and enduring spirit of a historic New England farmhouse thoughtfully renovated for today’s lifestyle. Set on 3.8 picturesque acres, this exceptional property blends timeless architectural character with the comforts and flexibility of a modern country home. Dating to approximately 1792, the property was a working farm for nearly two centuries, continuing its agricultural tradition into the 1980s. Today, its seasoned historic barns stand as a remarkable reminder of the property’s past while offering exciting possibilities for hobbies, animals, workshops, storage, or simply enjoying the romance of a classic Vermont-New Hampshire farm setting. Expansive lawns, mature trees & gardens, open countryside, and beautiful westerly views create a peaceful backdrop, with spectacular sunsets adding a magical close to each day. Inside, the renovated five bedroom farmhouse offers a dreamy, spacious cottage-inspired floor plan designed for comfortable everyday living and effortless entertaining. Generous living spaces, warm natural light, inviting gathering areas, and the character one hopes to find in a historic home create an atmosphere that feels both authentic and wonderfully livable. Long covered porches extend the living experience outdoors, providing the perfect perch for morning coffee, afternoon relaxation, or watching the sun disappear past the gardens and fruitful peach tree. Adding exceptional versatility, a private one or two bedroom ADU or in-law suite provides flexible space for guests, extended family, a home office or studio, or potential rental income. Whether envisioned as a hobby farm, a peaceful country retreat, a multigenerational property, or simply a beautiful place to call home, Cottage Hill Farm offers room to live, create, gather, and dream. Please join us for an Open House on Saturday, August 29th from 10 AM - 1 PM.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck - ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2 bedrooms plus a bonus room, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts. This is the ideal year-round lakefront paradise.
Description:Price adjustment! This BRAND NEW home is a fresh, modern offering in Etna. This contemporary offers a composed, modern feel, combining clean lines with durable finishes. The main level is designed for connection while maintaining definition, with kitchen and dining areas that flow naturally yet feel purposeful. Vaulted ceilings and large windows bring in abundant natural light, and the finishes are current and understated, keeping the focus on space and light. Four bedrooms are thoughtfully distributed across two floors, offering flexibility for guests, work-from-home needs, or long-term living. The primary suite is comfortable and private, and the first-floor laundry adds everyday convenience. A lofted living room adds architectural interest and a sense of openness, creating a light-filled upper level that overlooks the main living space. This area connects seamlessly to an additional second-floor bedroom, providing a flexible option for guests, a studio, or a quiet retreat. The setting is peaceful, with level land that invites a range of uses while remaining easy to maintain. Outdoor space extends the living experience, offering room to garden, gather, or simply enjoy the surroundings. A detached two-car garage and generous parking area complement the home without overwhelming the site. Inside, storage is well considered, with ample closets and practical spaces that support organized, everyday living. Located just minutes from Hanover and Dartmouth, and within the Dresden School District, the property offers a compelling balance of accessibility and a more relaxed pace. Clean, modern, and thoughtfully designed, this home is well executed and ready for immediate enjoyment.